<?php

			require_once("../db_connect.php");
			$sql = "select * from volunteer_information order by  updata_date desc limit 100";

			$res =& $db->query($sql);
			if (PEAR::isError($res)) {			//SQLの実行に失敗すればここでエラー文を出力
				die($res->getDebugInfo());
			}

			print("
					<font color='0e00b0' font size=5><i>お知らせ</i></font><hr size=5 width=520 color='#99ffff' align='left'/>
					<div style='border:thick solid #0080ff 0.;width:520;height:200;overflow:auto;
					scrollbar-3dlight-color:#000000;
					scrollbar-arrow-color:#000000;
					scrollbar-darkshadow-color:#ffffff;
					scrollbar-face-color:#ffffff;
					scrollbar-highlight-color:#ffffff;
					scrollbar-shadow-color:#000000;
					scrollbar-track-color:#ffffff;
					'>
					<Table border='0' width='500' height='200' cellspacing='0' bgcolor='#ffffff'>
					<Tr width=10>
				");
			while ($news =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {	//SQLの実行結果を表示

					$new01 = $news['updata_date'];
					$new02 = $news['volunteer_name'];
					$new03 = $news['pref'];


					echo "<td width=10>";
					echo "<td width=150>$new01</td>";
					echo "<td width=250><a href='volunteer_function/display_volunteer_information.php?volunteer_information_id=".$news['volunteer_information_id']."' >".$new02."</a></td>";
					echo "<td>$new03</td>";
					echo "</tr>";

			}

					echo "</table>";
					echo "</div>";




